/*
 Navicat Premium Dump SQL

 Source Server         : sqlserver11
 Source Server Type    : SQL Server
 Source Server Version : 16001000 (16.00.1000)
 Source Host           : WANG\SQLEXPRESS:1433
 Source Catalog        : Graduate Admission System
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001000 (16.00.1000)
 File Encoding         : 65001

 Date: 11/12/2024 15:55:03
*/


-- ----------------------------
-- Table structure for 考生导师匹配表
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[考生导师匹配表]') AND type IN ('U'))
	DROP TABLE [dbo].[考生导师匹配表]
GO

CREATE TABLE [dbo].[考生导师匹配表] (
  [examnumber] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [instructorid] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [current_wish] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT 1 NULL,
  [status] varchar(20) COLLATE Chinese_PRC_CI_AS DEFAULT 0 NULL
)
GO

ALTER TABLE [dbo].[考生导师匹配表] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of 考生导师匹配表
-- ----------------------------
INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'001', N'002', N'2', N'1')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'002', N'001', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'003', N'015', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'004', N'025', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'005', N'005', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'006', N'012', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'007', N'028', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'008', N'003', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'009', N'022', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'010', N'018', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'011', N'008', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'012', N'027', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'013', N'014', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'014', N'029', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'015', N'009', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'016', N'024', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'017', N'011', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'018', N'026', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'019', N'007', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'020', N'021', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'021', N'013', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'022', N'030', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'030', N'006', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'024', N'023', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'025', N'016', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'026', N'017', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'027', N'019', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'028', N'004', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'029', N'006', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'031', N'010', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'032', N'020', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'033', N'015', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'034', N'025', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'035', N'005', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'036', N'012', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'037', N'028', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'038', N'003', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'039', N'022', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'040', N'018', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'041', N'008', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'042', N'027', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'043', N'014', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'044', N'029', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'045', N'009', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'046', N'024', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'047', N'011', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'048', N'026', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'049', N'007', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'050', N'021', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'051', N'013', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'052', N'030', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'054', N'023', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'055', N'016', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'056', N'017', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'057', N'019', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'058', N'004', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'059', N'002', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'060', N'001', N'1', N'1')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'061', N'010', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'062', N'020', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'063', N'015', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'064', N'025', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'065', N'005', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'066', N'012', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'067', N'028', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'068', N'003', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'069', N'022', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'070', N'018', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'071', N'008', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'072', N'027', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'073', N'014', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'074', N'029', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'075', N'009', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'076', N'024', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'077', N'011', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'078', N'026', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'079', N'007', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'080', N'021', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'081', N'013', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'082', N'030', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'084', N'023', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'085', N'016', N'1', N'0')
GO

INSERT INTO [dbo].[考生导师匹配表] ([examnumber], [instructorid], [current_wish], [status]) VALUES (N'086', N'017', N'1', N'0')
GO


-- ----------------------------
-- Foreign Keys structure for table 考生导师匹配表
-- ----------------------------
ALTER TABLE [dbo].[考生导师匹配表] ADD CONSTRAINT [FK_考生导师选择_考生信息表] FOREIGN KEY ([examnumber]) REFERENCES [dbo].[考生信息表] ([examnumber]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

